<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>街舞风采</title>
<link rel="stylesheet" href="css/style.css" />
</head>

<body>


<% 
String personName=(String)session.getAttribute("yonghuming");
%>
<div class="top">
<font size="3" color=white>
<%
if(personName!=null)
{
out.println(""+personName);
%>
<a href="zhuxiao.jsp">注销</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<%
}
else
{
%>
	<a href="denglu.jsp">登录 </a>&nbsp;&diams;&nbsp;&nbsp;<a href="zhuce.jsp">注册</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
<%
}
%>
</font>
</div>

<div class="headl" style="float:left;margin-left:175px">
<img src="images/001.png" alt="logo">
</div>

<div class="headr" style="float:left;margin-left:50px">


<nav class="nav" >
<ul>
    <li><a href="zhuye.jsp">Home</a></li>
    <li><a href="Popping.jsp">Popping</a></li>
    <li><a href="Breaking.jsp">Breaking</a></li>
    <li><a href="Jazz.jsp">Jazz</a></li>
    <li><a href="Shuffle.jsp">Shuffle</a></li>
    <li><a href="huiyuan.jsp">Video</a></li>
    <li class="current active"><a href="FaBu03.jsp">上传</a></li>
</ul>
</nav> 


</div>

<br><br><br><br><br><br><br><br><br><br><br>
   <div align="center">
   <font size="5px"><a href="FaBu.jsp">我要上传</a><br></font>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");//载入驱动程序类别
String url="jdbc:odbc:shangchuantupian";
String user="";
String pwd="";//建立数据库链接，stuDataBase为ODBC数据源名称
Connection con=DriverManager.getConnection(url,user,pwd);
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);//建立ResultSet(结果集)对象,并执行sql语句
ResultSet rs=stmt.executeQuery("select * from tupian");
rs.last();
rs.beforeFirst();//移至第一条记录之前	
while(rs.next())//利用while循环配合next方法将数据表中的记录列出
{
String tupianxinxi=rs.getString("tupianmingzi");
%>

  	<img src="./tupian/<%=tupianxinxi%>"><br><br>

<%}%>
  </div>
</body>
</html>